| SySEVISCampus |
| Logical Entity Name | SySEVISCampus |
| Default Table Name | SySEVISCampus |
| Physical Only | NO |
| Definition | |
| Note |
| SySEVISCampus Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
SyCampusID |
int | NO | ||
SEVISSyCampusGrpID |
int | YES | ||
DSOSyStaffID |
int | YES | ||
| DSO_ID | char(10) | YES | ||
| SEVISDSOUserName | char(15) | YES | ||
| School_Code | char(15) | YES | ||
| Site_Name | varchar(60) | YES | ||
| RequiredDSOReview | bit | NO | ||
| SEVISFolder | varchar(120) | YES | ||
| EnableSEVISExtract | bit | NO | ||
| SEVISTransType | char(1) | YES | ||
| DateAdded | datetime | NO | ||
| DateLstMod | datetime | NO | ||
UserID |
int | NO | ||
| Ts | timestamp | NO | ||
| NotifyDSO | char(1) | NO | ||
| ExtractFolder | varchar(120) | YES | ||
| EVProgramNumber | varchar(9) | YES | ||
SySEVISCampusID |
int | NO |
| SySEVISCampus Primary and Unique Keys |
| Key Name | Key Type | Keys |
| PK_SySEVISCampus | PrimaryKey | SySEVISCampusID |
| SySEVISCampus_SyCampusID_U_C_IDX | Index | SyCampusID |
| SySEVISCampus Foreign Keys |
| Parent Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication |
| SyStaff | Non-Identifying | Zero or One to Zero or More | FK_SySEVISCampus_DSOSyStaffID_SyStaff_SyStaffID | DSOSyStaffID | NO | YES | ||
| SyCampusGrp | Non-Identifying | Zero or One to Zero or More | FK_SySEVISCampus_SEVISSyCampusGrpID_SyCampusGrp_SyCampusGrpID | SEVISSyCampusGrpID | NO | YES | ||
| SyCampus | Non-Identifying | One To Zero or More | FK_SySEVISCampus_SyCampusID_SyCampus_SyCampusID | SyCampusID | NO | YES | ||
| SyStaff | Non-Identifying | One To Zero or More | FK_SySEVISCampus_UserID_SyStaff_SyStaffID | UserID | NO | YES |
| Child Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication |
| SySEVISCampus Check Constraints |
| Check Constraint Name | CheckConstraint |